\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{Natalie Moore (NatalieMoore)}
\pdfinfo{
  /Title (microsoft-power-bi-for-beginners.pdf)
  /Creator (Cheatography)
  /Author (Natalie Moore (NatalieMoore))
  /Subject (Microsoft Power BI for Beginners Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{A3A358}
\definecolor{LightBackground}{HTML}{F9F9F4}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Microsoft Power BI for Beginners Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{Natalie Moore (NatalieMoore)} via \textcolor{DarkBackground}{\uline{cheatography.com/19119/cs/34195/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}Natalie Moore (NatalieMoore) \\
  \uline{cheatography.com/nataliemoore} \\
        \uline{\seqsplit{www}.jchmedia.com/}
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 15th September, 2022.\\
   Updated 15th September, 2022.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{3}

\begin{tabularx}{5.377cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Introduction to Power BI}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights.  \newline % Row Count 4 (+ 4)
Power BI lets you connect to data sources, visualize (or discover) what's important, and share that with collaborators or an audience.% Row Count 7 (+ 3)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} x{4.4793 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Use Power BI - Common steps}}  \tn
% Row 0
\SetRowColor{LightBackground}
1. & Bring data into Power BI Desktop, and create a report. \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
2. & Publish to the Power BI service, where you can create new visualizations or build dashboards \tn 
% Row Count 5 (+ 3)
% Row 2
\SetRowColor{LightBackground}
3. & Share dashboards with others \tn 
% Row Count 6 (+ 1)
% Row 3
\SetRowColor{white}
4. & View and interact with shared dashboards and reports in Power BI Mobile apps \tn 
% Row Count 9 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.64701 cm} x{4.32999 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Basic - Use the Power BI Service (SaaS) - Apps}}  \tn
% Row 0
\SetRowColor{LightBackground}
Go to: & \seqsplit{https://powerbi.microsoft.com} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{Apps are an easy and popular way to quickly create visuals in Power BI} \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{An app is a collection of preset, ready-made visuals and reports} \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{Quick and easy: you just have to press a few buttons or make a few comments, and you're quickly served a collection of entrees designed to go together, all presented in a tidy, ready-to-consume package.} \tn 
% Row Count 11 (+ 5)
% Row 4
\SetRowColor{LightBackground}
1 & Connect to data. select the Get Data button in the lower-left corner of the home page. \tn 
% Row Count 14 (+ 3)
% Row 5
\SetRowColor{white}
 & For software services like github, salesforce or google analytics, the Power BI service provides a collection of ready-made visuals pre-arranged on dashboards and reports \tn 
% Row Count 19 (+ 5)
% Row 6
\SetRowColor{LightBackground}
 & Pre-arranged visuals are known as {\bf{apps}} \tn 
% Row Count 21 (+ 2)
% Row 7
\SetRowColor{white}
2 & Update APP data in the Power BI service \tn 
% Row Count 23 (+ 2)
% Row 8
\SetRowColor{LightBackground}
 & Update immediately by clicking the update icon \tn 
% Row Count 25 (+ 2)
% Row 9
\SetRowColor{white}
 & Or to configure update settings, select the schedule update icon for the dataset, and use the menu that appears \tn 
% Row Count 29 (+ 4)
% Row 10
\SetRowColor{LightBackground}
 & Datasets tab is selected on the Settings page that appears. In the right pane, select the arrow next to Scheduled refresh to expand that section. The Settings dialog box appears on the canvas, letting you set the update settings that meet your needs. \tn 
% Row Count 37 (+ 8)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Power BI Usages}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{5.377cm}}{Create quick insights from an Excel workbook or a local database} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{Extensive modelling} \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{5.377cm}}{Real-time analytics} \tn 
% Row Count 4 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{Custom development} \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{5.377cm}}{Personal reports and visualization} \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{An analytics and decision engine to inform group projects, divisions, or entire corporations} \tn 
% Row Count 8 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.19002 cm} x{2.92928 cm} p{0.4577 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Basic building blocks of Power BI}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{5.377cm}}{Microsoft Power BI can be broken down into a few basic building blocks. Even seemingly complex things are built from basic building blocks} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\seqsplit{Visualizations} & Graphical representation of data, like a chart, a color-coded map &  \tn 
% Row Count 6 (+ 3)
% Row 2
\SetRowColor{LightBackground}
 & Might be simple, like a  single number that represents something significant &  \tn 
% Row Count 10 (+ 4)
% Row 3
\SetRowColor{white}
 & Might be visually complex, like a gradient-colored map that shows voter sentiment about a certain social issue or concern &  \tn 
% Row Count 15 (+ 5)
% Row 4
\SetRowColor{LightBackground}
 & Goal of a visual is to present data in a way that provides context and insights that are difficult to see from raw data &  \tn 
% Row Count 20 (+ 5)
% Row 5
\SetRowColor{white}
\mymulticolumn{3}{x{5.377cm}}{Datasets} \tn 
% Row Count 21 (+ 1)
% Row 6
\SetRowColor{LightBackground}
 & A collection of data that Power BI uses to create its visualizations &  \tn 
% Row Count 24 (+ 3)
% Row 7
\SetRowColor{white}
 & Can also be a combination of different sources, which you can filter and combine to provide a unique collection of data (a dataset) for use in Power BI &  \tn 
% Row Count 31 (+ 7)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{5.377cm}{x{1.19002 cm} x{2.92928 cm} p{0.4577 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Basic building blocks of Power BI (cont)}}  \tn
% Row 8
\SetRowColor{LightBackground}
 & Examples of connections available: Excel or a Microsoft SQL Server database, SharePoint Lists, in Azure or Oracle, or in a service like Facebook, Salesforce, or MailChimp &  \tn 
% Row Count 7 (+ 7)
% Row 9
\SetRowColor{white}
 & Access datasets through data connectors &  \tn 
% Row Count 9 (+ 2)
% Row 10
\SetRowColor{LightBackground}
 & Recommended to filter data before bringing it into Power BI to enable focus &  \tn 
% Row Count 12 (+ 3)
% Row 11
\SetRowColor{white}
\mymulticolumn{3}{x{5.377cm}}{Reports} \tn 
% Row Count 13 (+ 1)
% Row 12
\SetRowColor{LightBackground}
 & A collection of visualizations that appear together on one or more pages &  \tn 
% Row Count 16 (+ 3)
% Row 13
\SetRowColor{white}
 & Reports can be created in the Power BI service, or in Power BI desktop &  \tn 
% Row Count 19 (+ 3)
% Row 14
\SetRowColor{LightBackground}
 & Reports let you create many visualizations, on multiple pages if necessary, and let you arrange those visualizations in whatever way best tells your story. &  \tn 
% Row Count 26 (+ 7)
% Row 15
\SetRowColor{white}
\mymulticolumn{3}{x{5.377cm}}{Dashboards} \tn 
% Row Count 27 (+ 1)
% Row 16
\SetRowColor{LightBackground}
 & A report that can be shared with others &  \tn 
% Row Count 29 (+ 2)
% Row 17
\SetRowColor{white}
 & Other users or groups interact with your dashboards when they're in the Power BI service or on their mobile device &  \tn 
% Row Count 34 (+ 5)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{5.377cm}{x{1.19002 cm} x{2.92928 cm} p{0.4577 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Basic building blocks of Power BI (cont)}}  \tn
% Row 18
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{5.377cm}}{Tiles} \tn 
% Row Count 1 (+ 1)
% Row 19
\SetRowColor{white}
 & A single visualization on a dashboard &  \tn 
% Row Count 3 (+ 2)
% Row 20
\SetRowColor{LightBackground}
 & Can be moved around when creating or editing the dashboard &  \tn 
% Row Count 6 (+ 3)
% Row 21
\SetRowColor{white}
 & Can't be moved around when only viewing or consuming the report &  \tn 
% Row Count 9 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}---}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.41887 cm} x{2.70043 cm} p{0.4577 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Power BI parts}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{5.377cm}}{{\bf{Power BI consists of}}} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
Desktop App & Microsoft desktop application "Power BI Desktop" &  \tn 
% Row Count 4 (+ 3)
% Row 2
\SetRowColor{LightBackground}
Service App (SaaS) & An online SaaS (Software as a Service) service called the Power BI service &  \tn 
% Row Count 8 (+ 4)
% Row 3
\SetRowColor{white}
Mobile Apps & Native mobile Power BI apps for Windows, iOS, and Android. &  \tn 
% Row Count 11 (+ 3)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{5.377cm}}{{\bf{Flow of work}}} \tn 
% Row Count 12 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}---}
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{5.377cm}}{A common flow of work in Power BI begins in Power BI Desktop, where a report is created. That report is then published to the Power BI service and finally shared, so that users of Power BI Mobile apps can consume the information.}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}---}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}