A leading data analytics and digital solutions company, inspiring success through data A leading data analytics and digital solutions company, inspiring success through data
  • +44 0333 301 0302 Call Us Now
  • hello@figuringoutdata.com Drop Us a Line
  • Home
  • What we do
  • Professional Education
  • Blog
  • Contact Us

Visualising data with Power BI

Its common to hear the expression ‘storytelling with data’.  This suggests the use of charts or infographics to convey messages that can be quickly interpreted and understood, that influence opinion, perhaps shape a discourse, even inform a decision.

Those charts and infographics have to be interpreted and understood in a few seconds, contain only the most relevant information, contain effective signposting, and are supported by text telling the reader what they are supposed to understand.

Microsoft’s Power BI stands out as a tool of choice for those visualising data and looking to use data to communicate with clients and colleagues.  This course provides you with the skills you need.

Close up of three women, two sitting one standing all looking at laptop on desk
Following this course you will be able to:
red arrow small
Describe the differences and similarities in data visualisation methods beween Excel and Power BI.
red arrow small
Build and style charts in Power BI drawing upon data from multiple sources.
red arrow small
Transform source data in the Power Query Editor using both in-built functions and the M query language.
red arrow small
Develop interactive dashboards that the user can explore, drill down into, and report from.
red arrow small
Use the Data Analysis Expressions (DAX) script language to develop Measures, Columns, additional data tables, and dynamic chart filters.
red arrow small
Publish Power BI reports to the Power BI service for viewing across the Microsoft Teams and Sharepoint infrastructure.
red arrow small
Embed R and Python scripts into the data transformation process, and use scripts to create Charts.
red arrow small
Understand how Power BI authentication operates under the difference licensing options.
Workshop structure:
dark red arrow small
Unit 1 – Introduction to Power BI.

A brief recap of Excel charts. Connecting to and loading an Excel data source as a dataset. Building and styling charts in PowerBI, loading data in different formats plus cleaning and transforming data.

dark red arrow small
Unit 2 – Visualising data in Power BI.

Chart types for effective communication. The principles underpinning a dashboard and creating an interactive dashboard. Structuring data for best performance.

dark red arrow small
Unit 3 – Advanced techniques in Power BI.

Understand the capabilities of using DAX with Power BI and experience the full range of DAX functionality. Understand the full capabilities of the M query language. Integration of other programming languages, e.g. R & Python, to generate visualisations.

dark red arrow small
Each Unit involves a structured learning experience – supported, where necessary, by a workbook, a series of datasets, and supporting videos.

Our Services

  • Data Strategy
  • Digital Applications
  • Skills and Learning

Recent Posts

  • Close up of hands typing on keyboard with up arrows and profit line pointing upwards
    Why a Data Led Culture is key to su

    Mar 27, 2023

  • Data Important for Business
    Why Is Data Important for your Busi

    Mar 15, 2023

Policies

  • Data Privacy, Quality & Environmental
  • Information Security Management System
hello@figuringoutdata.com Drop Us a Line
+44 0333 301 0302 Call Us Now
Midsummer Court, 314 Midsummer Boulevard, Milton Keynes, MK9 2UB
Company Number: 11791420
All content Copyright FiguringOutData.com. All rights reserved.
Powered by FiguringOutData.com web services