"Start with a Power BI class and build your Government Management Dashboard."
Learn how easy it is to take your data analytics to a new level! Work with Excel, Power BI Desktop, and Power BI in the cloud and connect databases to create your own reports and interactive dashboards.
This three-day workshop is three (3) days of Instructor-led class. This instructor-led course provides students who work with Microsoft Excel or Power BI the skills to analyze data and create Power BI Tiles and Dashboards. You will understand how this powerful business intelligent platform can work for your organization.
The primary audience for this course is individuals who use Excel, Access, Power BI or SQL Server, business analysts, IT Professionals or deal with business intelligence. These individuals usually analyze data on a day-to-day basis and can benefit from the visualizations and the streamlined querying capabilities of Power BI.
In this accelerated class you will leverage your Excel skills, Power BI Desktop and then the Power BI Service and Azure to get deep insights into your data to drive intelligent business decisions that move your enterprise forward.
Introduction: The BI and Power BI Environment
Big Picture Demonstration
Excel Data Analysis
Power BI Desktop
Power BI Service (Cloud)
Power BI Editions (what you need to know)
Power BI Licensing (Free, Professional and Premium)
The Power Platform: Power BI, Power Apps and Power Automate
Demonstration: (Excel - Power BI Desktop - PB Cloud Service)
Module 1: Classic BI Data Analysis with Excel
Module 2: The Excel Data Model
Module 3: Power BI Desktop and Building Charts and Dashboards
· Developing Charts, Dashboards and Reports in Power BI Desktop
· Power BI Desktop - Data Modeling and Exploration
· Power BI Service - Collaboration and Distribution
Module 4: Importing Data from Files
Module 5: Importing Data from Databases
Module 6: Importing Data from Excel Reports
Module 7: Creating and Formatting Measures
Module 8: Visualizing Data in Excel
Module 9: Using Excel with Power BI
Module 10: Mentored Workshop
Use your organizations data and connect to network or Azure databases for multiple data sources to develop Dashboards for different departments in your organization. Each department uses the Power BI Desktop and then uploads department level information into the Power BI Cloud Service top rovide Department and Organization managers a top-level dashboard and the ability to drill-down to the detail level of each department.
We look forward to working with your organization to take you data analysis to the next level!