Business analytics and running
Answer the public is a website that tracks search-words. It is presented through linking a topic with popular prepositions. It is an excellent opportunity to use as basis for a blog post series. This posts topic is a response to "Can Power BI e-mail reports" The licensing model for Power BI gives different users different... Continue Reading →
AZ-900, where to start... Microsoft normally offers 1-day instructor-led training leading up to AZ-900. At least in Norway. Seems like a good place to start. I signed up three times this year, and they were all cancelled. Getting connections About a month ago, I attended a virtual MAIAD training (Modern Excel Analyst In A Day,... Continue Reading →
Budgeting is extremly useful both in business and in your personal life. It will give you predictability and control. If you are looking for something very simple and generic, you can google a local benchmark. In Norway this will typically be SIFO budget referance (calculator). If you are looking for more details and more control... Continue Reading →
I dag er det 12 uker til Sentrumsløpet. 12 uker er jo en veldig passe tidshorisont for å gjennomført et treningsprogram, så nå har jeg bestemt meg for å lage en plan. Det blir sub 55 planen. Årets første kondisblad kom i går, og sånn helt tilfeldigvis har de egne treningsprogrammer ferdig snekret til Sentrumsløpet.... Continue Reading →
Eksamen er overstått og jeg er i elendig form. Nå er det på tide å se litt nærmere på sub 50 planen min. Jeg tenker å ta utgangspunkt i Jack Daniels Running Formula. Han periodiserer treningen i fartstrening, intervalltrening og terskeltrening. Men jeg må tenke litt mer før jeg banker planen. Dagens økt; 2K oppvarming,... Continue Reading →
Edward Tufte is a writer, statistician and professor. The Visual Display of Quantitative Information is one of four books he has published. It is a book purely dedicated to visualization, which is pretty cool. I have come across his name in several forums and he has been refered to as "The godfather of visualization". Pretty... Continue Reading →
Top of mind tips on passing the exams required for getting the MCSA BI Reporting certification
Chapter 3 of Analyzing data With Microsoft Power BI and Power Pivot for Excel discuss the use of multiple fact tables in data modeling.... Let' go! The challenge in module 3 Creating cross-filters between fact tables so that your dimensions, on both sides of your fact tables, are correctly related. A typical example is sales... Continue Reading →
Chapter 2 of Analyzing data With Microsoft Power BI and Power Pivot for Excel discuss the use of header/details tables in data modeling. The scenario of header/detail tables appears when you have two fact tables with similar information, but with different granularity. Each of the fact tables has its own dimensions. It looks like two... Continue Reading →
Short summary or key learnings from chapter 1 of Analyzing Data With Microsoft Power Bi and Power Pivot for Excel
A few weeks ago, I decided to get certified in Power BI. The closest certification I could find is the MSCA BI Reporting sertification from Microsoft. So I will be writing a short series covering the journey. It will be a bit longer than what I first foresaw. The MCSA sertification is awarded after passing... Continue Reading →
Fjorårets julegaves fra mannen var startnummer til Sentrumsløpet og en haug andre goder som massasje, engasjert pt, barnepass osv. What?!? Jeg begynte selvsagt å løpe 1. juledag. Opptreningen har vært litt varierende. Løping med full A4-familie er ikke helt det samme som løping med samboer. På vei inn i startfeltet: Jeg må ikke tisse, jeg... Continue Reading →
Michelle Obama published her memoirs in 2018. The book release was followed by a tour in the form of a conversation or an interview — similar to a talk show. My husband surprised me with tickets to her tour, and even though these were quite pricy, it was definitely worth it! The event itself was... Continue Reading →
Kate Strachnyi is one of LinkedIn top voices within data science. She has an online book club that I'm part of. Deep Work by Cal Newport was the book of February 2019. Deep work: "Professional activities performed in a state of distraction-free concentration that push your cognitive capabilities to their limit." Cal Newport Deep Work... Continue Reading →
I currently have 9 pair of running shoes, and a standing arrangement with my husband to throw away a pair before I buy new ones. This is tricky as I really need them all. The pink Asics in the back are for running intervals on the track. Obviously I cannot throw away these. The black... Continue Reading →
Just a few weeks ago, I only knew the term "data mining" from my previous research into Bitcoins ( = complicated stuff!!) Imaging my surprise when I found out that data mining is a lot closer to home: Techniques used for discovering patterns in large data sets. Clustering analysis Segmentation or clustering is one of... Continue Reading →
Make over Monday week 6 This weeks data set is a set of metrics comparing the Chinese New Year and the American Thanksgiving celebrations. Looking at data per inhabitant changes the picture quite a lot. Especially Retail and Restaurant spending during the holiday. For this weeks challenge I kept it simple and I did the... Continue Reading →
Dashboard showing energy usage at Downing St 10 in the year 2017 in Tableau:
#makeovermonday week 5 2019 done in Tableau
Historically, differentiation as a business strategy has focused on product and marked development. Data and analytics have been mere support functions. In the age of digital disruption however, executing a successful data strategy can be a competitive advantage on its own — and that is extremely exciting. With the vast amount of data companies have... Continue Reading →
I love dashboards! Cognos, Click View, Power BI, Tableau or the pure Excel and Powerpoint version — I think it's amazing. Before even considering what to include in a dashboard, think about the purpose and the strategy of your company. Where are you going and how are you going to compete? Check out 5 reasons... Continue Reading →
This Christmas I got a start number for Sentrumsløpet April 27th. Also included in the present was a 'get-out-of-jail' card to go running whenever I want to, without the guilt! So — I have to get serious about running. Just under 4 months until race time. I am plotting and planning, and reviewing my stats.... Continue Reading →
LinkedIn editor Isabelle Roughol recently published an article about 50 Big Ideas for 2019. It got me thinking.... We are already well into the fourth industrial revolution, and the technological development is moving ahead exponentially. We are now at a point on the exponential curve where the speed of change is happening without precedence —... Continue Reading →
Google "Strategic planning" and you will have close to half a billion hits — that's a lot! It's a hot topic, and it has been for many years. Strategic execution, not so sexy. However, one cannot work without the other. The two concepts are complementary. Strategy fundamentals — the three levels of strategy The highest... Continue Reading →
A few weeks ago Elon Musk tweeted about working long hours and changing the world (or not). "There are way easier places to work, but nobody changed the world on 40 hours a week" I have let the statement stir for some time augmenting back and forth. It feels like a paradox. On one hand... Continue Reading →
Earlier this week a friend of mine came over. He is a Key Account Manager for a large, international company and he is in the process of preparing an internal Key Account presentation. I showed him the wonders of Excel to help him save time.One of the analysis I suggested that he include, is the... Continue Reading →
I do forecast modeling and scenario planning in Excel and it is quite simple: Be clear on your assumptions — typically top left in the worksheet Document your formulas by including a comment on input (column M below) Follow these two points and you can easily update your model, or do a handover to your... Continue Reading →
In several places I have worked, I have seen the need for a simple, regular report with key figures relevant to the execution of strategy. Strategy must be measurable and you have to follow-up regularly so you can respond quickly to any red flags. Simple, relevant and regular information, in the same format from week... Continue Reading →
I took all the MS Office courses I could get my hands during my first job. Getting up to speed with advanced Excel training from the start has been quite beneficial. I could hardly believe how useful it was — once I managed to convert the knitting-pattern of a baby sized sweater, with a complicated... Continue Reading →
