What is the benefit of parameterizing data sources in Power BI Desktop?

To easily toggle between different environments for testing purposes.

To improve the performance of data loading.

To create a more visually appealing report.

To collaborate with other users more effectively.

According to the video, what was the previously used method for parameterizing data sources in Power BI Desktop?

Clicking multiple times through the "Get Data" menu.

Writing custom code to define parameters.

Creating a separate report for each environment.

Manually editing the connection string.

What is the first step mentioned in the video for parameterizing a data source?

Enabling the "Always allow" checkbox in the parameters section.

Choosing a data source type (e.g., SQL Server).

Specifying the server name and database name.

Selecting "New Source" from the Home ribbon.

What does clicking "View" and then "Parameters" in the Power BI Desktop interface allow you to do?

See a list of available parameters and their values.

Edit the connection string for a data source.

Create new parameters for a data source.

Refresh the data preview for a report.

How can you modify the parameters used in a data source after it has been created?

By editing the query in the advanced editor.

By right-clicking on the data source in the Fields pane.

From the "Parameters" section in the ribbon.

Through the "Edit Queries" menu option.

What is the purpose of the "Adventure Works" database used in the video demonstration?

It is a real-world example of a large and complex data set.

It is a custom database created by the video author.

It is a database specifically designed for testing parameterization.

It is a sample database included with Power BI Desktop.

According to the video, what does the M code look like after a data source has been parameterized?

It will include the parameter names instead of the actual server name and database name.

It will require writing custom functions.

It will be much more complex and difficult to understand.

What does the video creator recommend doing if you have any questions or comments about parameterizing data sources?

In the context of the video, what is the meaning of the phrase "bananas"?

It refers to a technical term specific to Power BI Desktop.

It is a slang expression used to indicate something is exciting or impressive.

It is a reference to a type of fruit that is commonly used in data analysis.

It is the name of a new feature being introduced in Power BI Desktop.

Making data source parameters easy in Power BI Desktop

How is personal data collected? There are several ways that an unauthorised person can try and collect your data. These include: •phishing •smishing •vishing •pharming. Phishing Phishing is when a person sends a legitimate looking email to a user. The email contains a link to a website that also looks legitimate. The user is encouraged to click the link and to input personal data into a form on the website. The email could also simply ask the user to reply to the email with their personal data. The user is tricked into giving their personal data to a source that they believe is legitimate. However, both the email and the linked website are from a fake unauthorised source. The personal data that is input is then collected by an unauthorised person. This person can then use this data for criminal acts, for example, to commit fraud or steal the person's identity. Intimidation has become a common feature of phishing emails, threatening the user that they must click the link and rectify a situation immediately, or there will be a further issue. The aim of a phishing attack is to steal the user's personal data. Figure 5.1: Phishing. A real-life example of phishing PayPal have been the subject of several different phishing emails. Users receive an email that looks as though it has been sent from PayPal, as it has the PayPal branding. The email normally warns of an issue such as unexpected activity on their account, or that some kind of verification of their account is required. The user is then asked to click a link to log into their account and resolve the issue. The link takes them to a webpage that looks like the PayPal login page. If the user inputs their login details into this page, they will not be taken to their account. It is often at this stage that the user may realise that the email and webpage are fake. However, they have already given the unauthorised person their PayPal login details. Figure 5.2: An example of a phishing email claiming to be from PayPal. How to recognise phishing There are several guidelines to be aware of regarding emails to avoid being subjected to phishing. These include: •Don't even open an email that is not from a sender that you recognise or a trusted source. •Legitimate companies will never ask you for your personal data using email. Be immediately suspicious of any email that requests your personal data. •Legitimate companies will normally address you by your name. Be suspicious of any email that addresses you as ‘Dear Member' or ‘Dear Customer'. •Legitimate companies will send an email that uses their domain name. If you hover your mouse over the sender's name, it will show the email address that the email is sent from. If this does not look legitimate, for example, does not contain the correct domain name, then it is probably fake. For example, if the sender's email is user@paypal1.com rather than user@paypal.com, this is from an incorrect domain name. •Legitimate companies are protective of their professional reputation and thoroughly check any communications. They will make sure that all information given is grammatically and correctly spelt. Be suspicious of any email that contains bad grammar or spelling mistakes. •A link in an email from a legitimate company will also normally contain the domain name of the company. You can sometimes hover over the link, or right click and inspect the link, to see the address of the URL that is attached. If the URL does not contain the domain name, or also contains typical errors such as spelling mistakes, then be suspicious of this. PRACTICAL ACTIVITY 5.02 Ask a friend or a member of your family if they have ever received an email that they believed was a phishing email. Ask them how they identified it was phishing. Ask them if they know all of the given guidelines for identifying phishing emails. Smishing Smishing (or SMS phishing) is a variant of phishing that uses SMS text messages to lure the user into providing their personal details. The user is sent an SMS text message that either contains a link to a website, in the same way that phishing does, or it will ask the user to call a telephone number to resolve an urgent issue. The same advice can be followed for smishing as given for phishing. The user must question at all times any links that are sent from an unknown or suspicious user. It is advisable that if a user believes the message may be legitimate, to type in the domain name for the legitimate company website into their web browser, rather than following the link in the message. Users should block any numbers that they believe are suspicious to prevent any further risk of smishing from that number. Figure 5.3: Smishing. Vishing Vishing (or voice phishing) has the same aim as phishing, to obtain a user's personal details. The user receives a telephone call that could either be an automated system or could be a real person. An automated voice could speak to the user and advise them that an issue has occurred, such as there has been suspicious activity regarding their bank account. The user may then be asked to call another number, or just to simply press a digit and be directed to another automated system. This system will ask them to provide their bank account details to resolve the issue. The bank account details have then been obtained by the unauthorised user and can be used to commit a crime against the user. The automated system could be replaced by a real person who will try to do the same thing. They will try to convince the user that there has been an issue with an account they have and to provide the log-in details or PIN for the account to verify who they are so the issue can be resolved. The precaution to take for vishing is that no company will ever call you and ask you to provide any log-in details or PIN details over the telephone. They may ask you to provide other personal information, and if you are in doubt that the person on the other end of the phone is legitimate, it is always advisable to put the phone down and call the company back on a legitimate number that you may already know or can obtain. Figure 5.4: Vishing. Pharming Pharming is when an unauthorised user installs malicious code on a person's hard drive or server. The malicious code is designed to redirect a user to a fake website when they type in the address of a legitimate one. The fake website is designed to look like the legitimate one, to trick the user and make sure they are not aware that their request has been redirected. The user will then enter their personal details into the fake website, believing it is the legitimate one, and the unauthorised person will now have their personal data. A common technique used in pharming is called domain name server (DNS) cache poisoning. This technique exploits vulnerabilities in the DNS and diverts the internet traffic intended for a legitimate server toward a fake one instead. The unauthorised user needs to find a way to install the malicious code on the computer. They often hide the malicious code in an email attachment or link. When the user opens the email attachment or clicks the link, the malicious code is downloaded also. Figure 5.5: Pharming. The aim of a pharming attack is also to steal a user's personal data. A real-life example of pharming In 2007 50 different companies all over the world were subject to a pharming attack, these included PayPal, eBay, Barclays bank and American Express. Over a three-day period, hackers managed to infect over 1000 PCs a day with a malicious pharming code. When users who had been infected visited the websites of the different companies, they were redirected to a legitimate-looking version of the site that was designed to steal their personal data. The original email, containing the malicious code, was set up to look like a shocking news story. Users were encouraged to click a link in the email to find out more information. The code was downloaded when the user clicked the link. This was quite a sophisticated attack that required legitimate looking websites to be set up for a large number of companies. It is not known how much money the hackers were able to retrieve as a result. How to prevent pharming All of the guidelines to avoid being subjected to phishing are also relevant for recognising pharming. There are also several other precautions that can be taken to check for pharming attacks. These include: •Have a firewall installed and operational. A firewall monitors incoming and outgoing traffic from your computer. It checks this traffic against set criteria and will flag and stop any traffic that does not meet the criteria. A firewall could detect and block suspicious traffic, such as a malicious code trying to enter your system. •Have an anti-virus program installed that is designed to detect malicious pharming code. You need to scan your computer on a regular basis to check for any malicious code. It is advisable to set up an automatic scan on a daily basis at a time when your computer will normally be switched on. •Be aware when using public Wi-Fi connections. A hacker could look to directly access your computer and install the malicious code if you are connected to a public Wi-Fi connection. It is often advisable to use a VPN when using public Wi-Fi. This will help shield your internet activity and personal details from a hacker, making it more difficult for them to access your computer. Smishing can also be used as a form of pharming. A user is sent a link, that when they click is designed to download malware onto their mobile device. Therefore, it is advisable to have security software installed on your mobile and also scan it regularly to detect any presence of malware.

Revealing personal data can lead to threats like identity theft, fraud, bullying, and blackmail. 1.Identity Theft Definition: Identity theft occurs when someone steals your personal information and uses it without your permission. This can include your name, Social Security number, or bank details. Example: If someone gets your Social Security number, they could open a credit card in your name and run up bills that you would have to pay. 2.Fraud Definition: Fraud is when someone deceives another person to gain something of value, like money or personal information. This is often done through lies or tricks. Example: A person might call you pretending to be from your bank and tell you that you need to confirm your account details. If you give them your information, they may steal your money. 3. Bullying Definition: Bullying is when someone repeatedly hurts, threatens, or picks on another person. This can happen in person or online (cyberbullying). Example: If someone sends hurtful messages or spreads rumors about you on social media, that’s a form of bullying. 4. Blackmail Definition: Blackmail is when someone threatens to reveal harmful or embarrassing information about you unless you give them something they want, usually money or favors. Example: If someone takes a private photo of you and threatens to share it unless you pay them, that’s blackmail. Summary Identity Theft: Stealing personal information for illegal use. Fraud: Deceiving someone for personal gain. Bullying: Repeatedly hurting or threatening someone. Blackmail: Threatening to expose information unless demands are met. Understanding these terms helps you recognize and protect yourself from potential dangers in both real life and online. If you see any signs of these actions happening, it’s important to talk to a trusted adult or authority figure. There are several guidelines for you to be aware of to keep your personal data confidential: •Have strong passwords set on any account that holds personal data. Stronger passwords include characters, numbers and symbols and are not a recognisable word. •Encrypt (scramble text so that it cannot be read without a decryption key) any personal data that you store on your computer. •Have a firewall present, scanning incoming and outgoing data from your computer system. firewall : a security measure that can be implemented to monitor traffic into and out of a computer and prevent external users gaining unauthorised access to a computer system. A firewall is a security measure that helps protect a computer system by monitoring and controlling the traffic that comes into and goes out of the system. Think of it as a barrier between your computer and the outside world. It prevents unauthorized users from accessing your computer while allowing authorized traffic to pass through. •Regularly scan your computer with preventative software, such as an anti-virus package, that is used to identify a virus on a computer and remove it. Anti-virus: software that is used to identify a virus on a computer and remove it •Make use of any biometric devices (devices that measures a person's biological data, such as thumbprints), that are built into technology. biometric devices: Unique physical characteristic of a person that can be used by a computer for identification purposes. https://www.aratek.co/news/biometric-devices-definition-and-examples Biometric devices are tools that use unique physical characteristics of a person for identification purposes. This means they can recognize who you are based on features that are unique to you. Here are some examples of biometric characteristics: Fingerprint Recognition, Facial Recognition, Voice Recognition •Only visit and provide data to websites that are a trusted source. •Do not open any email attachments from a sender you do not recognise. •Check the URL attached to any link requesting data to see if it is genuine. •Be cautious about any pictures or opinions that you post or send to people. •Remove data about your location that is normally attached to your photos and videos that you may post, such as geotags. Geotag: an electronic tag that assigns a geographical location A geotag is an electronic tag that assigns a specific geographical location to a piece of information, like a photo or a video. Geotags can help people understand where a photo was taken or where an event occurred, making it easier to organize and find information based on location. •Do not become friends on social networking sites with people you do not know. •Set all the privacy controls to the most secure setting that are available on social media accounts. •Report and block any suspicious user. •Use a nickname or pseudonym when using the internet for entertainment, for example, playing games. •If it is possible, use a virtual private network (VPN), an encrypted connection that can be used to send data more securely across a network. Virtual private network (VPN) : an encrypted connection that can be used to send data more securely across a network A Virtual Private Network (VPN) is a special way to connect to the internet that keeps your information safe. Imagine you are sending a secret message to a friend. You want to make sure no one else can read it while it travels. A VPN helps you do just that! It creates an encrypted connection, which means it turns your message into a code that only your friend can understand Example: Public Wi-Fi Safety: When you use public Wi-Fi, like in a café, your data can be easily accessed by hackers. If you connect to a VPN while using that public Wi-Fi, your data is encrypted, making it much harder for anyone to steal your information.

There are two numbers you need to know about climate change. The first is 51 billion. The other is zero. Fifty-one billion is how many tons of greenhouse gases the world typically adds to the atmosphere every year. This is where we are today. Zero is what we need to aim for. To stop the warming and avoid the worst effects of climate change, humans need to stop adding greenhouse gases to the atmosphere. This sounds difficult, because it will be. Every country will need to change its ways. Virtually every activity in modern life – growing things, making things, getting around from place to place – involves releasing greenhouse gases, and as time goes on, more people will be living this modern lifestyle. That’s good, because it means their lives are getting better. Yet if nothing else changes, the world will keep producing greenhouse gases, climate change will keep getting worse, and the impact on humans will be catastrophic. But “if nothing else changes” is a big If. I believe that things can change. We already have some of the tools we need, and as for those we don’t yet have, we can not only invent, but also deploy them, and, if we act fast enough, avoid a climate catastrophe. Two decades ago, I would never have predicted that one day I would be talking in public about climate change. My background is in software, not climate science. Things changed for me when I met with two former Microsoft colleagues who were starting non-profits focused on energy and climate. They brought along two climate experts who were well versed in the issues, and the four of them showed me the data connecting greenhouse gas emissions to climate change. I kept learning everything I could about climate and energy, agriculture, oceans, sea levels, glaciers, power lines, and more. One thing that became clear to me was that our current sources of renewable energy – wind and solar, mostly – could make a big dent in the problem, but we weren’t doing enough to deploy them. It also became clear why, on their own, they aren’t enough to get us all the way to zero. The wind doesn’t always blow and the sun doesn’t always shine. Within a few years, I had become convinced of three things: 1. To avoid a climate disaster, we have to get to zero. 2. We need to deploy the tools we already have, like solar and wind, faster and smarter. 3. We need to create breakthrough technologies that can take us the rest of the way.

Certainly, let's expand on each section in detail so you can learn more from the provided text: # Summary This text aims to explain various aspects related to technology, particularly focusing on a concept known as "Tech Disruption." It explores how technology affects different sectors, outlines the conditions for tech disruption, discusses the industrial revolutions, introduces the laws of disruption, and mentions factors influencing technology choices. ## Concept of Technology **Technology** encompasses a range of elements within organizations. It includes **expertise, equipment, and procedures** used to convert inputs, such as resources or raw materials, into outputs, which can be products or services. This involves various aspects, such as **product design, production techniques, quality assurance measures, human resource development, and management systems**. In essence, technology represents the tools and knowledge used to create and deliver goods or services effectively. ## What is Tech Disruption **Tech Disruption** refers to a phenomenon where smaller companies with limited resources successfully challenge well-established incumbent businesses. This disruption is primarily driven by **technology**, which acts as the catalyst, enabler, or even the sole reason behind the change. The significance of this concept lies in the fact that entrepreneurs must make careful and thoughtful decisions when it comes to adopting and investing in technology. **Why it's Important?** These decisions are crucial because they involve significant investments and will have a substantial impact on a company's ability to create, innovate, and operate its services in a sustainable and cost-effective manner. ## Four Main Impact **Tech Disruption** has four main impacts on businesses and industries: 1. **Shifting Customer Expectations**: As technology evolves, customer expectations change. Companies must adapt to meet these evolving demands to remain competitive. 2. **Enhanced Products Through Data**: Data-driven insights improve the productivity and efficiency of assets, leading to better products and services. 3. **New Partnerships and Collaboration**: Tech disruption encourages companies to form new partnerships and collaborations, recognizing the importance of working together to stay relevant. 4. **Transformation of Operating Models**: Traditional operating models are being transformed into digital models, where technology plays a central role in how businesses operate and deliver value. ## The 11 Macro Sources of Distribution The **11 Macro Sources of Distribution** represent various factors that influence the distribution of resources and opportunities in society. These factors include: 1. **Wealth Distribution**: How wealth is distributed among individuals and entities. 2. **Education**: The availability and quality of education opportunities. 3. **Infrastructure**: The state of infrastructure, such as transportation and communication networks. 4. **Government**: Government policies and regulations that impact resource distribution. 5. **Geopolitics**: Geopolitical factors, such as international relations and conflicts. 6. **Economy**: Economic conditions and trends, including markets and financial systems. 7. **Public Health**: The state of healthcare and public health systems. 8. **Demographics**: Characteristics of the population, such as age and gender. 9. **Environment**: Environmental factors and sustainability concerns. 10. **Media and Telecommunications**: The role of media and communication technologies. 11. **Technology**: Technological advancements and their impact on society. ## When Does Tech Disruption Happen? **Tech Disruption** occurs when specific conditions are met: ### Technology Is Mature Enough - **Technology Accessibility**: Technology must be accessible to a wide range of people and organizations. - **Critical Mass**: It should have reached a critical mass where it can create significant impact. - **Affordability**: Technology must be affordable for businesses to adopt. ### Sector Is Ready For Change - **Tech Infrastructure**: The sector should have the necessary technological infrastructure in place. - **Policy Framework**: A conducive policy framework is essential to support and regulate the use of technology. - **Lack of Disruption**: If the sector is stagnant or facing issues, it becomes ripe for tech disruption. ### Sector + Technology + Timing + Product - **Mature Technology with an Unready Sector**: If technology is mature but the sector is not ready, it can lead to building the wrong product based on incorrect assumptions. - **Unmatured Technology with a Ready Sector**: Conversely, if technology is not matured but the sector is ready, it may take longer to develop the product. ## Ready for Industri 5.0? This section briefly outlines the five industrial revolutions: 1. **Industri 1.0 (1784)**: Marked by mass production assembly lines using electrical power. 2. **Industri 2.0 (1870)**: Introduced mechanization, steam, and water power. 3. **Industri 3.0 (1969)**: Characterized by automated production, computers, IT systems, and robotics. 4. **Industri 4.0 (Present)**: Involves smart factories, autonomous systems, IoT (Internet of Things), and machine learning. 5. **Industri 5.0 (Future)**: Envisions mass customization and cyber-physical cognitive systems. ## Three Laws of Disruption These laws explain the nature of disruption: 1. **Disruption Comes to All**: Disruption is a universal phenomenon; it affects all industries and businesses sooner or later. 2. **Product-Market Fit**: Disruption occurs due to changes in Product-Market Fit, which means aligning a product with its target market effectively. 3. **Methods to Change Product-Market Fit**: To address disruption, a company can change the product, the target market, or influence people's preferences regarding the product. ## The 40% Rule This rule provides a framework for evaluating the fit between a product and its market: - **Value Proposition**: The product should solve customers' problems effectively. - **Channels**: The product should be able to reach customers cost-effectively. - **Monetization**: Customers should be willing to pay for the product. ## PMF Framework: 5 Steps to Product/Market Fit The **PMF (Product/Market Fit) Framework** consists of five steps: 1. **Business Modeling**: Developing a business model that aligns with the market. 2. **Market Validation**: Confirming that there is demand for the product in the market. 3. **Customer Interviews**: Gaining insights from potential customers. 4. **Product Development and Customer Acquisition**: Creating the product and acquiring customers. 5. **Product Analytics**: Using data to determine if the product has achieved Product/Market Fit. ## Factors Determining the Choice of Technology Several factors influence the choice of technology: 1. **Government Policy**: Government regulations and policies can encourage or restrict the adoption of specific technologies. 2. **Available Resources**: The resources, both financial and human, impact the adoption of technology. 3. **Technological Capability**: The organization's technological capabilities influence the choice of technology. 4. **Existing Technological Level**: The current technological state of the industry or organization plays a role. 5. **Institutional Arrangement**: Organizational structures and arrangements affect technology choices. ## Conclusion In conclusion, the text emphasizes the critical role of technology in driving change and disruption in various industries. It highlights the need for informed decision-making when it comes to technology investments, as well as the conditions necessary for tech disruption to occur. Understanding the historical context of industrial revolutions, the laws of disruption, and the factors influencing technology choices is essential in today's fast-paced and tech-driven business environment. Embracing technology disruption is crucial for transforming business models and adapting to evolving market dynamics.

Related quizzes

Related quizzes