Overview

Video subtitles lessons in these languages: हिंदी भाषा - Bahasa Indo - தமிழ் மொழி - ภาษาไทย - Tiếng Việt__________________Power BI Desktop is free and the first lesson shows you how to install itLearn, with a simple and intuitive APP, to manipulate and model large quantities of data from any source. In a company or at a job interview it will make the difference.__________________Objectives of the courseThe course aims to provide the necessary tools to start using Power BI, illustrating the steps to connect an existing data source (such as Excel, Access, SharePoint) and model the data from different visual angles with extreme simplicity.Power BI is a business intelligence solution developed by Microsoft that allows companies to visualize data and share insights across the organization. Users can transform data into engaging visualizations and create interactive reports and customized dashboards.Power BI dashboards provide an overview of the most important business metrics and monitor the company's progress in real-time. Power BI reports, on the other hand, offer a more detailed analysis with visualizations such as charts, tables, and maps.Power BI supports data security with features such as row-level security and data protection6. Additionally, Power BI facilitates collaboration and sharing of insights through integration with other Microsoft applications like Azure and Teams.The course also includes a section dedicated to configuring the Microsoft 365 account in terms of users and groups. This is preparatory knowledge for using any application, including Microsoft Power BI.On this topic you can download 85 PowerPoint slides navigable by clicking for topics to support the video lessons.__________________Downloadable software to synchronize with Power BI to manage the businessSoftware open in the structure and in the Visual Basic Application code. Maybe you can do whatever you want. 1. Software license Microsoft Access Company Management and ISO 9001 to synchronize with Power Bi. License of life. See Screenshots du Forms;2. Software license Microsoft Access Management of training courses to synchronize with Power Bi. License of life. See Screenshots du Forms.You can also find links to reach many video tutorials on YouTube to learn to use them with subtitles in 18 languages.See details at the bottom of this presentation.__________________EBooks downloadable in PDF format- 500-page manual on Power BI and DAX language (measures and calculated columns);- 172 pages ebook (4 chapters) on the Global Administrator of the Microsoft 365 account;- 1670 pages ebook (26 chapters) on the professional use of the PC.See Screenshots of the Indices in the relative sections.______________________2460 Multiple choice quizzes with score return and explanation of correct answers- 600 on general knowledge of the Power BI tool;- 1300 on formulas DAX (Data Analysis Expression);- 140 on Microsoft 365 Administration;- 420 on the topics of the Ebook for professional use of the PC.**Take the quizzes in advance in the dedicated sections______________________DATABASE ACCESS DAX FORMULAS MANAGEMENT (see screenshots in section 2 in preview) - DownloadableThis database contains 7230 DAX formulas to be used as detailed in section number 7. Practicing with the ADVENTURE WORKS model you will notice how easy it is to set up formulas that then, in graphic objects, will produce data to be consulted dynamically with equal ease.All calculations are set on the aforementioned model, so you can quickly see the results.1. FUNCTION CATEGORIES - Functions are grouped by utility categories as reported in Microsoft Support: Aggregation (22), Logic (15), Date and Time (24), Table Modification (32), Business Intelligence (35), Parent/Child (5), Filter (19), Relationship (4), Disclosure (31), Financial (49), Residual (5).2. EACH FUNCTION IS DETAILED AS FOLLOWS:- Name (which is then the one to be used in expressions);- Brief description (for the immediate classification of the utility);- In-depth description (general overview of what can be done using it);- 10 examples of business usage scenarios (e.g. units sold for which revenues have exceeded a certain threshold);- 10 examples of formulas in which it is used alone (e.g. account of the total number of orders);- 10 examples of formulas in which it is used with other functions as an argument (e.g. account of the number of orders filtered by type of customer);- 10 examples of formulas in which it is used as an argument to other functions (e.g. sum of order count for each customer)._____________________Two Microsoft Access-licensed software to sync with Power BIa) COURSE MANAGEMENT: training organisations, cultural and sports associations: courses, students, teachers, course registers; face-to-face, distance and videoconference courses. Specific environment for HACCP courses.It's open in the structure, and you can customize the masks and reports in your language.b) COMPLETE MANAGEMENT OF THE COMPANY AND THE ISO 9001 QUALITY SYSTEM.It's open in the structure, and you can customize the masks and reports in your language.Environments:1. Management control: fixed costs, variable costs and break-even points;2. Supplier management: personal data, invoices, performance evaluation;3. Customer management: customer files, invoices, satisfaction surveys, complaint management;4. Management of invoicing: stock to be invoiced, VAT balance, cash flow with the possibility of simulation on day "N";5. Warehouse management: inbound and outbound movements, delivery notes, value and stock;6. Human resources management: personal data of employees, functions, hourly wages, attendance register;7. Management of orders and quotes: from customers and suppliers;8. Management of the ISO 9001 quality system: inspection audits, improvement projects, preventive actions, quality plans, non-conformities, registrations and their revisions, management review, performance indicators, SWOT analysis, calibration sheet of measuring and precision instruments.

Skills

Reviews