Business Intelligence using Power BI and Business Data Analysis Using MS Excel Training in Lagos, Port Harcourt and Abuja

  1. Power BI’s strength and weakness compared to the other popular BI tools
  2. Important concepts of Power BI: real-time insights, drilldown, drill through, management dashboards, live connection, data governance, real-time collaboration, going from data to insights and from insights to action, trigger alerts, controlled access etc.
  3. Connecting to any type of data source (from structured to unstructured which will require some transforming)
  4. Getting data from existing services, organizational content pack, flat files and live databases
  5. Data Transformation (very broad and requires some knowledge of data analysis) and we will use DAX and M formulas too.
  6. Creating relationships between the datasets and leveraging hierarchy (a.k.a. data modelling)
  7. Creating Reports
  8. Visualizations and the science behind choosing the right visuals
  9. Importing custom visuals (especially word cloud for sentiment analysis and other very useful non-native visuals)
  10. Creating dashboards
  11. Publishing Reports from the Power BI Desktop and pinning to dashboards
  12. Scheduling refresh and configuring data gateways
  13. Q & A Natural Language query
  14. Integrating with Cortana
  15. Live Dashboards
  16. Collaboration and sharing
  17. Printing and Export to PowerPoint
  18. Analyzing the dashboard data (report) from Power BI service in Excel (new feature)
  19. Value Proposition to corporate customers
  20. Use case scenarios for entire company or business unit or departments
  21. Access from mobile app and setting data alerts (automated notifications when something of note happens)
  22. Lots of interaction and practice

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store