Power Bi for Data Analysis and Visualization

Course Name: Power Bi for Data Analysis and Visualization

Venue: Tech for Development Training Center, Nairobi, Kenya

Event Date: 9th to 11th December 2019

Course Fee: KES 30,000 OR USD 400

Registration: Register online

Tech For Development-T4D would like to invite you to a high impact Training Course in Power Bi for Data Analysis and Visualization to be held in Nairobi, Kenya from 9th to 11th December 2019.

We are an international training, capacity building and tech solutions organization that offers tech solutions, scheduled and tailor made training and capacity building solutions to individuals and development agencies in Africa and around the world.

We provide our training programs with a capacity-building goal, so as to ensure that, our training programs contribute to sustainable change.

Impact Evaluation, Monitoring and Evaluation, Academic Research, Market Research, Field Research, Agriculture, Health, Education, WASH, Handicapped, Human rights, Emergencies/disasters, Advocacy, Education, Environment, Small business development, Community development, Rural development, Women, Youth, Population, Rehabilitation, Culture, Capacity Building, Appropriate technology, Income, generation, Private sector, Refugees/displaced.

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.

The free Power BI Desktop tool can get and model data from almost anywhere using the same Power Query and Power Pivot tools many Excel users will be familiar with. Then quickly create impressive interactive reports using the sophisticated charting and visualization gallery. You can even embed Excel charts, tables, PivotTables and dashboards in your Power BI dashboards using the free Power BI Publisher add-in for Excel.

You want to analyze data from single or multiple sources? You want to create your individual dataset based on these sources and transform your results into beautiful and easy-to-make visualizations? Moreover, you want to share your results with your colleagues or collaborate on your project? Finally, you want to be able to access your data from multiple devices? Then the Power BI tools are the tools to choose for you.

• People who never worked with Power BI and who want to understand how to use these tools
• Anyone who is interested in learning how to connect the different Power BI tools with each other
• People who want to understand how to create customized visuals with the Power BI Developer tools

• No prior Power BI or BI experience required
• Windows 7 onward so you can install the Power BI Desktop application
• Basic understanding of data analysis is a plus but not required

3 days

What you will learn:

• Get to know the different tools of the Power BI universe and learn how to use them
• Understand Power BI Desktop and its components
• Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
• How to work in the different views of the Data Model
• How to create calculated columns and measures
• How to build relationships between different tables
• How to create a report with different interactive visualization types
• Learn how to use Power BI service to create dashboards and to share and publish your results
• How to access your results from multiple devices using Power BI Mobile

Module I

Quick Start Power BI Service

• Get Power BI Tools
• Introduction to Tools and Terminology
• Dashboard in Minutes
• Refreshing Power BI Service Data
• Interacting with your Dashboards
• Sharing Dashboards and Reports

Module II

Getting and Transforming Data with Power BI Desktop

• Introduction to Power BI Desktop
• Getting Data: Excel vs Power BI Desktop & Service
• Data Structure for Q&A
• Direct Query vs Import Data

Modeling with Power BI

• Introduction to Modeling
• Setup and Manage Relationships
• Cardinality and Cross Filtering
• Default Summarization & Sort by
• Creating Calculated Columns

Module III

Power BI Desktop Visualisations

• Creating Visualisations
• Color Formatting
• Setting Sort Order
• Scatter & Bubble Charts & Play Axis
• Tooltips
• Slicers, Timeline Slicers & Sync Slicers
• Cross Filtering and Highlighting
• Visual, Page and Report Level Filters
• Drill Down/Up and Hierarchies
• Reference/Constant Lines
• Tables, Matrices & Conditional Formatting
• KPI's, Cards & Gauges
• Map Visualizations
• Custom Visuals
• Managing and Arranging
• Drillthrough
• Custom Report Themes
• Grouping and Binning
• Selection Pane, Bookmarks & Buttons

Module IV

Power BI Service Visualisation Tools

• Introduction
• Standalone Tiles
• Data Driven Alerts
• Quick and Related Insights

Publishing and Sharing

• Sharing Options Overview
• Publish from Power BI Desktop
• Publish to Web
• Share Dashboard with Power BI Service
• Workspaces and Apps (Power BI Pro)
• Content Packs (Power BI Pro)
• Print or Save as PDF
• Row Level Security (Power BI Pro)
• Export Data from a Visualization
• Publishing for Mobile Apps
• Export to PowerPoint

Module V

Refreshing Datasets

• Understanding Data Refresh
• Personal Gateway (Power BI Pro and 64-bit Windows)
• Replacing a Dataset
• Troubleshooting Refreshing

Power BI and Excel Together

• Options for Publishing from Excel
• Pin Excel Elements to Power BI
• Connect to Data using Power BI Publisher/Analyze in Excel
• Excel 2016 Publish: Upload and Export to Power BI
• Sharing Published Excel Dashboards

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

Upon successful completion of this training, participants will be issued with a certificate of participation.

The training is residential and will be held at T4D Training Centre in Westlands Nairobi, Kenya. The course fees cover the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

We can also tailor-make our courses for you. This way, you/your organization will benefit by:

• Using own tools during the training
• Being able to choose areas of interest you wish the trainer to put more emphasis on
• Taking the course in-house or at a venue of choice
• Cutting on the cost of transport and accommodation

For further inquiries, please contact us on details below: 

Email: outreach@t4d.co.ke

Mobile: +254 (0) 729166479

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: outreach@t4d.co.ke

Mobile Number: +254 706909947

The course fee is KES 30,000.00 or USD 400.00 exclusive of VAT. The course fees covers the course tuition, training materials, two (2) break refreshments, lunch and study visits. Participants will cater for their travel and accommodation costs.

Payment should be transferred to Tech For Development - T4D account through bank on or before the course starting date.

Send proof of payment to outreach@t4d.co.ke

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

1. Participants may cancel attendance 14 days or more prior to the training commencement date.
2. No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met

Kindly visit this link to see video and photo testimonials of our previous training events.  

Need more information? Kindly visit this link to see answers to frequently asked questions.

Tel: +254 706909947
Email: outreach@t4d.co.ke
Website: www.t4d.co.ke

Kind regards.

Kelvin K. Mwangi
Customer Relationship Officer,
Tech For Development.
Innovation for impact