Welcome to Power BI

Welcome

A Guide to completing this course

We are super excited to have you walk this journey with us. Welcome. 

Our goal with this course, and all our courses, is for you to: 

  • get some real data modeling experience
  • create a portfolio of evidence for future employers
  • apply your skills to simulated real-world scenarios

Dystopia needs your help

Let's find out more...

Dystopia is an emerging metropolis growing in the ruins of what once was the great city of New York. Most of the earth was destroyed by a massive earthquake and tsunamis wiping out cities in different parts of the globe. 

To rebuild what’s left and create order, the ruling government of Dystopia decided to implement a system that divides its people into different groups based on their specific skill set and innate talents and gifts. The government conducts DNA tests on all citizens of the metropolis. The test result determines the group that individuals are paired into.

Citizen Factions

Citizens are divided into 4 groups: 

  1. artists, 
  2. engineers, 
  3. biotechnicians (in charge of growing things)  and 
  4. architects

The Unlisted

A defective group called “the unlisted” don’t belong to any group, they are outcasts. They threaten to disrupt the order of the metropolis by stealing and controlling the data. We have to save the data and metropolis.

Dystopia is made up of 11 districts which were managed independently although each district contributes to the growth of the city. With the government’s intervention, a new governing body will be put in place to manage all 11 districts.

Your task

Help Dystopia combat crime

The Government of Dystopia convenes a secret organisation, called the luminous ones or LM13, which has 3 main goals. 

  • Goal 1: gather data from multiple sources 
  • Goal 2: Analyze this data to obtain useful insights on the city 
  • Goal 3: Create a surveillance dashboard that will help combat crime and corruption in the city.

Welcome to the “Data Analysis With Power BI” course. In this course, you will embark on a journey in the world of data analysis. You will learn how to use data that you can find from multiple sources; online or from your own personal files and create your very own dashboard and report in Power BI. 

Data analysis is key for a data science career

What does this course cover?

Course Outcomes:

With this course, you will learn how you can analyze data to obtain useful information from it and communicate that information using a dashboard and report on power BI. At the end of the course, you should understand the following: 

Hover on the icons below to find out more about each section

1 2 3 4 5 6 7 8

Your Task: to save Dystopia...

Icons

To watch for

Throughout the course, we will be using icons to display various items which you need to be aware of.  Here are some icons to keep an eye out for:

Video

This icon is used to represent a video

Quiz

This icon is used to represent a quiz

Example

This icon is used to represent a question

Task

This icon is used to show a task

Recap

This icon is used to recap your learning

To book your spot – click here

We will be talking to Brent George from GetSet Games who will be sharing lessons on what it takes to build a career in the game development world.

Join Brent and TechWays for a free webinar on Thursday 3 March 5:30-6:30pm SA time. Brent has worked at 𝐖𝐚𝐫𝐧𝐞𝐫 𝐁𝐫𝐨𝐬 𝐆𝐚𝐦𝐢𝐧𝐠, 𝐢-𝐀𝐧𝐢𝐦𝐚𝐭𝐞.𝐧𝐞𝐭, 𝐔𝐛𝐢𝐬𝐨𝐟𝐭 etc. He worked on James Cameron’s 𝐀𝐕𝐀𝐓𝐀𝐑 game, 𝐁𝐚𝐭𝐦𝐚𝐧: 𝐀𝐫𝐤𝐡𝐚𝐦 𝐎𝐫𝐢𝐠𝐢𝐧𝐬 and so much more. 

We are truly excited to learn from someone who has over 30 years of game development experience – the tips and best practices to building a game development career. 

This event is suitable for learners, parents and their teachers. Book your spot HERE

type ( ) is a built-in function (still to cover what built-in functions are later) that determines the Data Type of any data presented. 

To book your spot – click here

We will be talking to Jason Suttie from Devson. Jason has been in the tech world since he was six years old. He headed IT innovation unit at RMB and has since left to start up his own software consulting company – solving problems and building solutions for clients around the world. 

Let’s hear more about the trends in the software and programming industries, where jobs are moving to and what kind of skills you’ll need in this exciting world of opportunities out there. 

Book your spot HERE

To book your spot – click here

We will be talking to Noelene Kinsley from GC Network. Noelene has been specialised in the exciting career of Genetic Counseling and wants to share her passion for making the world a healthier place using genetics….and data science technology. 

Let’s hear more about the trends in the health/genetics industries, where jobs are moving to and what kind of skills you’ll need in this exciting world of opportunities out there. 

This event is suitable for learners, parents and their teachers. Book your spot HERE

To access the recording – click here

Calling on all high schoolers interested in tech as a career to join us on 16 September at 5:30pm. If you missed it, we’ll host another one on 18 November. 

We covered the following:

  • general tech career tips
  • a few “hot button/in-demand” career pathways and jobs
  • the skills needed to access these careers
  • some of the job realities in these careers

To access the recording – click here

To book your spot – click here

 

Calling on all high schoolers interested in tech as a career. Join us on Thursday 17 March at 5:30pm.

 

We will be sharing:

  • general tech career tips
  • a few “hot button/in-demand” career pathways and jobs
  • the skills needed to access these careers
  • some of the job realities in these careers

There are only 100 spaces – so book your spot now – please RSVP here Book

To book your spot – click here

#WOW – What Outstanding Work – Awards: join us to learn from our students. 

Our top 20 learners are from St Andrews for Girls, Reddam Umhlanga, Evolve Online, Nova Pioneer and Sutherland High

Learners will be presenting their final projects. Come celebrate their successes and lessons learnt with us at our TechWays #WOW Awards.

This event is suitable for learners, parents and their teachers. Book your spot HERE

Variables

More about variables

Info about variables

Integrated Development Environment – A digital environment used to develop games, software, hardware, that offers integration from debugging to compiling. 

print ( ) is a built-in function (still to cover what built-in functions are later) that executes data inside the brackets. The results get printed out on the console/results section.

input ( ) is a built-in function (still to cover what built-in functions are later) allows a user to insert info into a program/the code. 

Mad Libs is a phrasal template word game created by Leonard Stern and Roger Price. It consists of one player prompting others for a list of words to substitute for blanks in a story before reading aloud.

Indentation – In the written form of many languages, an indentation or indent is an empty space at the beginning of a line to signal the start of a new paragraph.

str ( ) is a built-in function that converts and sequence of characters (numbers especially) in to text. 

\ – escape character is a string character that tell Python that the next character after it should be taken as a string and not as an instruction.

In programming Concatenation is a process of appending one string to another. 

String Special Characters

There a number of special string characters that have different functions when used inside ” “. Here’re some useful and common ones:

  • \n – Newline – Everything after it goes to next line.
  • \t – Horizontal tab – creates a tab space, similar to when you use ‘tab’ on keyboard.
  • \b – backspace – deletes the character before the it.
  • \r – carriage return – same as \n

String Built-in Functions/Methods

There are a lot of strings functions/methods in Python. Find full list in course manual. Here’s are some that you find useful in this course:

Functions

  • len(varName) – Returns the length of a list, string
  • “char to add”.join(varName) – Converts the elements of an iterable into a string.

Methods 

  • varName.capitalize() – Converts the first character to upper case.
  • varName.center(length) Returns a centered string
  • varName.count(“?”) Returns the number of times a specified value occurs in a string.
  • varName.endswith(“?”) – Returns true if the string ends with the specified value.
  • varName.find(“?”) – Searches the string for a specified value and returns the position of where it was found.
  • varName.format(placeholder = value) – Formats specified values in a string.
  • varName.index(“?”) – Searches the string for a specified value and returns the position of where it was found.
  • varName.isalnum() – Returns True if all characters in the string are alphanumeric.
  • varName.isalpha() – Returns True if all characters in the string are in the alphabet.
  • varName.isascii() – Returns True if all characters in the string are ascii characters.
  • varName.isdecimal() – Returns True if all characters in the string are decimals.
  • varName.isdigit() – Returns True if all characters in the string are digits.
  • varName.isidentifier() – Returns True if the string is an identifier.
  • varName.islower() – Returns True if all characters in the string are lower case.
  • varName.isupper() – Returns True if all characters in the string are upper case.
  • varName.isnumeric() – Returns True if all characters in the string are numeric.
  • varName.isprintable() – Returns True if all characters in the string are printable.
  • varName.isspace() – Returns True if all characters in the string are whitespaces.
  • varName.istitle() – Returns True if the string follows the rules of a title.
  • varName.ljust(value) – Returns a left justified version of the string.
  • varName.rjust() Returns a right justified version of the string.
  • varName.lower() – Converts a string into lower case.
  • varName.upper() – Converts a string into upper case.
  • varName.strip() – Returns a trimmed version of the string.
  • varName.lstrip() – Returns a left trim version of the string.
  • varName.rstrip() Returns a right trim version of the string.
  • varName.partition() – Returns a tuple where the string is parted into three parts.
  • varName.replace(“old”, “new”) – Returns a string where a specified value is replaced with a specified value.
  • varName.rfind() – Searches the string for a specified value and returns the last position of where it was found.
  • varName.rindex() – Searches the string for a specified value and returns the last position of where it was found.
  • varName.rpartition() – Returns a tuple where the string is parted into three parts.
  • varName.rsplit() – Splits the string at the specified separator, and returns a list.
  • varName.split() – Splits the string at the specified separator, and returns a list.
  • varName.splitlines() – Splits the string at line breaks and returns a list.
  • varName.startswith() – Returns true if the string starts with the specified value.
  • varName.swapcase() – Swaps cases, lower case becomes upper case and vice versa.

Troubleshooting is a form of problem solving, often applied to repair failed products or processes on a machine or a system. It is a logical, systematic search for the source of a problem in order to solve it, and make the product or process operational again.

Prompt – to  cause or bring about; to make something happen. For example making someone to say or write something.

Heterogeneous – diverse in character or content; containing different things

Homogeneous – of the same kind; alike throughout.

Text editor – is the part of the IDE where you write the code. Most text editors highlight words with different properties like functions to help you distinguish them from one another. 

Linux Essentials

Introduces Linux as an operating system, the basic open source concepts and an understanding of the Linux commands. Linux is crucial for cybersecurity.

Comptia
Security+

Gives you the baseline skills you need to secure a company’s systems, software and hardware. This certificate gives practical hands-on skills to pursue a career in cyber security

Certified Ethical Hacker

Will give you skills in Information Security Threats and Attack Vectors, Attack Detection, Attack Prevention, Procedures, Methodologies and more.