Chelsea assistant coach Gianfranco Zola claims that even though Eden Hazard may not be known for his industry off the ball, Chelsea still needs him to assist the team.The Belgium winger hasn’t really impressed in all his outing this term after he was deployed by new coach Sarri to play as a false nine.Chelsea defeated Tottenham 2-1 on penalties to reach the EFL Cup final on Thursday with Hazard scoring the Blues’ second goal in a second leg.“I was very much like Eden,” Zola told reporters, according to FourFourTwo.“I was a very positive player, I liked to move around the pitch, find the spots on the pitch where I could receive the ball, turn and make the damage to the opposition.Chelsea hat-trick hero Tammy Abraham hopes for more Andrew Smyth – September 14, 2019 Tammy Abraham hopes this season will be his big breakthrough at Chelsea after firing his first hat-trick for the club in Saturday’s 5-2 win at Wolves.“I was very, very similar and I do understand that. I believe we try to give him this but also to be an organised team defensively and offensively. Especially offensively. That’s why we ask Eden sometimes to put himself about in working hard.“I know that’s not his best quality. We understand that sometimes he needs to be fresh when he receives the ball. There is no doubt that we are on the same page. We want to find a common ground where he can get the best out of himself and the team can benefit from him.“Not only when he is scoring goals but when we have moments in the game where we need everybody to defend and everybody to press. That’s exactly what we are trying to do. Eden, I think, I have to be fair that he has been doing it.“He has been trying to do it. We are very demanding because we want to do it all the time. I am sure that we will find a compromise. I am not in a position to criticise a player like Eden. We believe, Maurizio said one thing, that the potential of Hazard is greater than the performances.“So he is not criticising what Eden is doing but he believes he can do much more for himself and the team. That’s all he is saying. This is the situation he wants Hazard to understand. Again, when we see his performances we look forward to seeing more and more.”
Penton Media has folded Digital Content Producer magazine into millimeter, its other video industry magazine. The merger is effective with the April issue.The decision to fold Digital Content Producer into millimeter will “better serve the entire video production industry,” a Penton spokesperson told FOLIO:. No layoffs were associated with the merger, she said.Millimeter’s frequency will increase from bimonthly to monthly and its circulation will jump from 30,000 to 60,000. Digital Content Producer, a monthly, carried a circulation of 57,000. Penton plans to relaunch millimeter’s Web site in July, the company said.
The NOOK Newsstand for Barnes & Noble’s e-reader offering NOOK has added more titles from Meredith and Time Inc. to its periodical roster. NOOK is also updating its newsstand to 1.3 software, increasing capability for the platform. Interactive options now include video, audio podcasts, animations and photo galleries, according to a Barnes & Noble press statement.Time Inc. releases FORTUNE, PEOPLE, SPORTS ILLUSTRATED and TIME magazines for the NOOK; the publisher says all 21 of its titles will be available for the NOOK by year’s end. Current print subscribers can download these digital editions for free.Meredith Corp. brings Parents, Ladies’ Home Journal, Eating Well, Midwest Living, Siempre Mujer, Traditional Home and Fitness magazines to the digital newsstand, with Better Homes and Gardens being added this fall. Meredith plans to have almost two dozen titles on the NOOK by 2012. Subscriptions and single copy sales are available for Meredith users, with a free 14-day trial for digital subscription purchase. In April, the NOOK Color refreshed its offerings by including web options, built-in email and new additions to Shop on NOOK Color. This increased functionality brings the e-reader NOOK (once viewed solely as a platform for digital versions of PDFs) in direct competition with tablet competitors like the iPad and the Motorola Xoom.Time Inc. is making it entire magazine portfolio available on several platforms, with all 21 of its titles to be available for download on the iPad by January 2012.
The Praetorian Group has been expanding its public safety business rapidly since last year. Now, they’re branching out to the larger local government space with the acquisition of EfficientGov.Terms weren’t disclosed.Public safety—markets like fire and police departments, emergency management and corrections—can account for more than half of a municipality’s budget, says Alex Ford, CEO of Praetorian, but there’s another half his company didn’t have an entrance into. Areas like planning and development, education and transportation were untapped. Ford says the digital media model Praetorian uses in its current markets—a mix of analysis and news content, along with grant assistance and education—can be applied to an audience of municipal leaders as well.”Public safety is a subset of local government,” he says. “It’s a logical extension to take that model to the rest of local government with a similar mission.”He adds: “We see the same exact model that’s working so well for us in public safety applying to local government more broadly, accessing an opportunity that’s more than twice the size.”See also: Praetorian Buys Fire Chief Assets from Penton The EfficientGov acquisition doesn’t get them all the way there—at least as comprehensively as they serve the public safety market—but Praetorian now has a foothold with the decision makers that hold influence over multiple segments, inside and outside of public safety. Ford says the deal brings about 44,000 new government officials into the fold.EfficientGov will continue to operate as a standalone brand, but will aggregate content from Praetorian’s network of more than 15 sites, Ford says.Prior to the acquisition, the company also announced that John Suhler, formerly the head of private equity firm Veronis Suhler Stevenson, has joined Praetorian in an advisory role.”Since his retirement from VSS, he now has the opportunity to take a more formal role and is excited about our opportunity to scale and grow the business,” Ford says. “He has an incredible amount of experience and knowledge of how to grow digital media companies. His connections are probably, bar none, some of the best in the media world, so he’s going to be a great asset.”
WOBURN, MA – The Middlesex District Attorney’s Office has been awarded a $50,000 grant from the Insurance Fraud Bureau of Massachusetts, in coordination with the Commissioner of Insurance, to fund investigations and prosecutions of automobile insurance fraud, Middlesex District Attorney Marian Ryan announced today.The grant was presented to District Attorney Ryan by Daniel Johnston, Executive Director of the Insurance Fraud Bureau of Massachusetts. The $50,000 grant is funded by Arbella Mutual Insurance Company, as part of a program in coordination with the Commissioner of Insurance and the Insurance Fraud Bureau which has been used to fund insurance fraud investigations across the state since 2003.The Middlesex District Attorney’s Office Special Investigations Unit investigates cases of fraud, embezzlement, drug trafficking, white collar crimes and related illegal activity. The Unit includes a team of Assistant District Attorneys, Financial Analysts, Forensic Examiners, Paralegals and State Police detectives.The grant money received yesterday will pay for continued investigations by prosecutors in the Special Investigations Unit of the Middlesex District Attorney’s Office.Middlesex District Attorney’s Office(NOTE: The above press release is from the Middlesex District Attorney’s Office.)Like Wilmington Apple on Facebook. Follow Wilmington Apple on Twitter. Follow Wilmington Apple on Instagram. Subscribe to Wilmington Apple’s daily email newsletter HERE. Got a comment, question, photo, press release, or news tip? Email email@example.com.Thank You To Our Sponsor:Share this:TwitterFacebookLike this:Like Loading… RelatedState Police Ask For The Public’s Help Identifying Vehicle In Fatal Motorcycle Crash In WoburnIn “Police Log”Wilmington Man Injured In Fatal Car Crash In WoburnIn “Police Log”Middlesex DA Marian Ryan and State AG Healey Launch Recertification Course For Online Mandated Reporter TrainingIn “Government”
WILMINGTON, MA — Below are recent articles about Wilmington — published online between July 7, 2019 to July 14, 2019 — that residents should consider reading:Wilmington Town CrierRink planning flexibility limited by Lizzie McDermottOpen space plan update by Lizzie McDermottWilmington Town Crier sports stories can be read HERE.Wilmington AdvocateNoneWilmington PatchNoneLowell SunFinding ‘A happy accident’ by Emma MurphyNot your mother’s roller derby by Alana MelansonLike Wilmington Apple on Facebook. Follow Wilmington Apple on Twitter. Follow Wilmington Apple on Instagram. Subscribe to Wilmington Apple’s daily email newsletter HERE. Got a comment, question, photo, press release, or news tip? Email firstname.lastname@example.org. Share this:TwitterFacebookLike this:Like Loading… RelatedWILMINGTON AROUND THE WEB: The Best Stories From Wilmington’s NewspapersIn “Community”WILMINGTON AROUND THE WEB: The Best Stories From Wilmington’s NewspapersIn “Community”WILMINGTON AROUND THE WEB: The Best Stories From Wilmington’s NewspapersIn “Community”
A cancer patient and a driver of an ambulance died in a road accident on Dhaka-Chittagong highway in Sitakunda upazila of Chittagong early Thursday.The deceased are Akkas Mia, 65, a resident of Agrabad area in Chittagong city and ambulance driver Sanaullah, 34, of Itbaria village of Patuakhali sadar upazila.The Chittagong-bound ambulance carrying cancer patient Akkas Mia along with his relatives hit a vehicle in Chhoto Darogarhat area of the upazila leaving six people in the ambulance injured, said Sitakunda fire service station official Owasi Azad.Members of Sitakunda fire service rushed to the spot and took the injured to the local upazila health complex where physicians declared Akkas Mia and Sanaullah dead.Other injured — Rani Begum, wife of Akkas Mia, his son Zahid, his relatives Halima Begum and Ismail — were later transferred to Chittagong Medical College and Hospital.
BNP chairperson Khaleda ZiaBangladesh Nationalist Party (BNP) chairperson Khaleda Zia on Saturday said her party wants the next election to be held under a non-party neutral government so that all political parties can join it.”We want multiparty democracy to be restored in the country and the next election to be held in a free and fair manner with the participation of all parties,” she said.”But the election must be held under a neutral administration. Or else, it won’t be possible to hold an impartial election,” she added.The BNP chief came up with the remarks while exchanging greetings with the Christian community on the occasion of the Christmas Day.Bangladesh Christian Association arranged the programme at the BNP chairperson’s Gulshan office.Khaleda alleged that the government is again trying to hold a 5-January-like unilateral election to hang onto power.She also came down hard on the government for what she said its repressive acts to weaken BNP.Khaleda voiced concern over the growing abuse of drugs by the young generation.”The ruling party men are involved in drug trading. And they’re working to destroy the young generation with it. Many of them were arrested but they have not been punished,” she said.Mentioning that the country is passing through a critical time, the BNP chief urged people of all religions and communities to get united to get rid of it.Later, Khaleda cut a cake with the Christian community members marking the Christmas Day.The BNP chief also wished the Christian community members a happy and prosperous life.
PM in the list of top 100 global thinkersPrime minister Sheikh Hasina has made her room in the list of top 100 global thinkers as the famous US-based Foreign Policy journal came up with a register of world leading thinkers.“Sheikh Hasina has responded to the greatest security challenge facing Bangladesh with a generosity . . . Rather than turn away the approximate 700,000 Rohingya who fled persecution in Myanmar, Hasina welcomed them and allowed them to remain in her country,” the journal wrote justifying their decision for incorporating in the list of its Current Issue: Winter 2019.Sheikh Hasina has been named among the 10 top global thinkers in the category “Defense and Security”.Referring to the background of the list, the Foreign Policy said they selected the leading global thinkers cautiously considering their stake in shaping the world mind.“In a year of worldwide economic crisis and dangerous wars, of radical innovation and newfound realpolitik, street revolution and blunt rhetoric, we could think of no better way to make sense of it than through the big ideas of those who shape our understanding of the world,” the article read.
Samuel Shields died while detained in the Prince George’s County Jail.Officials are investigating the death of a 49-year-old man at Prince George’s County Jail in Upper Marlboro, Md., even as his wife is demanding answers.”I just want the truth of why my husband is dead,” Regina Shields, a Northeast Washington, D.C. resident, told NBC 4 Washington.Metro Transit Police said they got into an altercation with Samuel Shields over a $2 fare at Addison Road Metro station on June 17. They pepper sprayed him and took him into custody.According to the statement of charges against Shields, he was arrested for alleged theft under $100, obstructing and hindering and resisting arrest.Regina Shields said that behavior does not sound like that of her husband, a Jamaican-born aspiring reggae artist, who went by the stage name, Potcovah.“I’m very upset about what went on because he didn’t deserve this,” she said. “If he got violent either someone provoked him or whatever. But he’s not a violent person at all.”Jail spokeswoman Yolonda Evans, however, confirmed that when Metro police brought Shields to the jail about 12:38 p.m., he was “disorderly” and had to be separated from the other inmates.“They just keep saying he was talking loud, wouldn’t put on the uniform, and I don’t know what happened after that,” Regina Shields said in the interview.According to Evans, while Samuel Shields was being processed for intake he went into “medical distress” though she wouldn’t go into specifics because of the ongoing investigation.“Our emergency response team and our medical staff began to perform life-saving measures until paramedics arrived and took him to Southern Maryland Hospital where he was pronounced dead at 11:57 p.m.,” the jail spokeswoman said.The situation was a rare one for the jail, Evans added.“Medical emergencies, we have them all the time,” she said. “[But], typically, we may experience an in-custody death once every 12-18 months. The majority of those are deemed suicides.”Regina Shields acknowledged that her 460-pound spouse had suffered from serious medical conditions, including congestive heart failure, sleep apnea and mental illness. However, she doubted that those conditions caused her husband’s death.“I think it was foul play,” she said. “I really do, in my heart.”
D.C. Council Chairman Phil Mendelson is paying for haircuts for D.C. public and charter school students who have made prior arrangements.On Aug. 28, Mendelson, a Democrat, will be present at the Davis Barber and Beauty Supply shop located on Livingston Road, S.E. in Ward 8 from 12-1 p.m. The barbers at the shop will cut and style the hair of the students for no charge from 10 a.m.-2 p.m. The chairman’s office of constituent services is coordinating the event and Mendelson is more than happy to participate.“This is the second year we’ve done it,”Mendelson said in a statement to the AFRO. “It’s a great community activity. It’s a way of helping kids who probably can use the savings from getting a free haircut for other back-to-school needs.”Davis Barber is co-owned by Derek and Marsten Davis and is considered a District institution.Derek E. Davis is a former president of the National Association of Barber Boards of America. He wrote the first barbering curriculum for the D.C. public schools in 1982, taught barbering in various public high schools for many years and has chaired the District of Columbia Barber and Cosmetology Board.His late father, Willie Roscoe Davis, opened Davis Barber shop in 1968 and, throughout the years, became an advocate for the profession in the city. In 1995, Willie Davis was appointed to the District’s Board of Barbers and Cosmetology and he was inducted posthumously (he died in 2001) into the Barber Hall of Fame by the 83rd National Association of Barber Boards of America in Las Vegas, Nev., on Sept. 16, 2009.Davis told the AFRO he was approached by Mendelson’s staff for the free haircuts.“I got a call from the chairman’s chief of staff who asked me whether I wanted to participate this year,” Davis said. “I agreed to do so. I have been performing activities like this, such as cutting young people and supervising barber students in cutting homeless veterans hair, for decades.”Davis said that what Mendelson is doing is good for the community.“We believe in giving back to the community that has been good to us,” he said.Mendelson agrees with Davis on that.“It’s also a way of reminding students how important school is and showing kids that the community cares–not just me, but the barbershop and the other people who participate in this event,” he said. “This is something that makes the kids look good and feel good about going back to school.”
Kolkata: The state government on Monday informed the Calcutta High Court that hawkers in Salt Lake Sector V area will be relocated elsewhere only after the state has a hawker policy in place. Soon after hearing the state’s stand, the High Court stayed the process of evicting the hawkers encroaching upon the bus route of Sector V till August 30. The stay of Justice Debangshu Basak came in the wake of the Salt Lake Sector V Hawkers’ Welfare Association, moving the high court against the eviction order. Also Read – Rain batters Kolkata, cripples normal lifeThe next hearing in this regard will be held on August 23. The counsel appearing on behalf of the state claimed that the government is absolutely against forcible eviction and wants proper rehabilitation of the hawkers. Hawkers in Salt Lake Sector V were taken to two plots of land in the area on Saturday where the Nabadiganta Industrial Township Authority plans to relocate them. It may be mentioned that police wants the hawkers on Ring Road, the stretch from the SDF intersection in GN Block to Technopolis building to be vacated for smooth traffic movement. It may be mentioned that hawkers in Sector V had demonstrated by keeping their shops closed on Friday to protest the order asking them to clear three main thoroughfares or face eviction. They also allegedly prevented several delivery persons of app-based food delivery services on their way to offices in Sector V.
Halloween celebrations in India are on the rise, thanks to the young and cosmopolitan crowd. If you are attending such an event and have your costume sorted but wondering about the make up, make sure you are getting few tricks in place. Experts share some quick tips and tricks for you to keep in mind: -Skin test: First step to trying anything new on your face is to do a skin test at least 24 hours prior. Though one doesn’t have to spend on expensive makeup for one day, make sure you buy approved makeup for face. Also Read – Add new books to your shelf-Base: Let’s start with the base. If you are dressing up as a zombie, ghost, witch, vampire or a mummy, go for a pale look. Your base should be a few shades lighter than your skin tone to achieve this. For other looks, your regular base should be fine. -Eyes: First thing, people look at the eyes, so make sure your eye makeup is good. Dark Gray or Black eyeshadow suit most of the dark characters. Just play around with the shapes according to your costume. Deep red blended with black is perfect for a Vampire. Also Read – Over 2 hours screen time daily will make your kids impulsiveA Mermaid or a Fairy offer a good opportunity for one to show off their colorful eyeshadow palette especially blues and greens. One can also use crystal stones or tattoos around the eyes. If you are comfortable with lenses, adding colored ones would take your costume a notch higher. -Hair: Your hair depends on the costume. You can buy or hire a colorful, fancy wig at very reasonable prices from party shops or online. If you don’t plan to use wigs, then you can use a hairspray to set your hair. Colored and sparkly hairspray can also be used which are available in the market. -Lips: Red, Burgundy, Black, Purple are shades for the Halloween season. Apart from these basic shades, gold and shimmery lips can also be played with. A quick tip is to outline the lips with eyeliner pencil to check if you are happy with the shade, as they are easy to remove and smudge less than your lip color. -Don’t forget that it is equally important for you to get rid of that makeup too replace coconut oil with Make up remover. The presence of harsh and punitive chemicals on your skin for prolonged hours, needs sheen and rejuvenation. So, use coconut oil or jojoba oil to remove that excess from your skin for it to breathe and be smooth, once again. -Apply cold cream or wipes on your skin as it shall help in removing the halloween make up. Cold Cream shall nourish the effects of the makeup on your skin thereby giving soft skin. -Using dark colors on skin can leave a stain or impression on your skin. In such cases, people with sensitive and delicate skin can use toothpaste as a rescuer from getting liberated from these colours. A paste of water and baking soda can also be used.
Microsoft Power BI Desktop contains a rich set of data source connectors and transformation capabilities that support the integration and enhancement of source data. These features are all driven by a powerful functional language and query engine, M, which leverages source system resources when possible and can greatly extend the scope and robustness of the data retrieval process beyond the possibilities of the standard query editor interface alone. As with almost all BI projects, the design and development of the data access and retrieval process has great implications for the analytical value, scalability, and sustainability of the overall Power BI solution. Our article is an excerpt from the book Microsoft Power BI Cookbook, written by Brett Powell. This book shows how to leverage Microsoft Power BI and the development tools to create better data driven analytics and visualizations. In this article, we dive into Power BI Desktop’s Get Data experience and go through the process of establishing and managing data source connections and queries. Examples are provided of using the Query Editor interface and the M language directly to construct and refine queries to meet common data transformation and cleansing needs. In practice and as per the examples, a combination of both tools is recommended to aid the query development process. Viewing and analyzing M functions Every time you click on a button to connect to any of Power BI Desktop’s supported data sources or apply any transformation to a data source object, such as changing a column’s data type, one or multiple M expressions are created reflecting your choices. These M expressions are automatically written to dedicated M documents and, if saved, are stored within the Power BI Desktop file as Queries. M is a functional programming language like F#, and it’s important that Power BI developers become familiar with analyzing and later writing and enhancing the M code that supports their queries. Getting ready Build a query through the user interface that connects to the AdventureWorksDW2016CTP3 SQL Server database on the ATLAS server and retrieves the DimGeography table, filtered by United States for English. Click on Get Data from the Home tab of the ribbon, select SQL Server from the list of database sources, and provide the server and database names. For the Data Connectivity mode, select Import. A navigation window will appear, with the different objects and schemas of the database. Select the DimGeography table from the Navigation window and click on Edit. In the Query Editor window, select the EnglishCountryRegionName column and then filter on United States from its dropdown. Figure 2: Filtering for United States only in the Query Editor At this point, a preview of the filtered table is exposed in the Query Editor and the Query Settings pane displays the previous steps. Figure 3: The Query Settings pane in the Query Editor How to do it Formula Bar With the Formula Bar visible in the Query Editor, click on the Source step under Applied Steps in the Query Settings pane. You should see the following formula expression: Figure 4: The SQL.Database() function created for the Source step Click on the Navigation step to expose the following expression: Figure 5: The metadata record created for the Navigation step The navigation expression (2) references the source expression (1) The Formula Bar in the Query Editor displays individual query steps, which are technically individual M expressions It’s convenient and very often essential to view and edit all the expressions in a centralized window, and for this, there’s the Advanced Editor M is a functional language, and it can be useful to think of query evaluation in M as similar to Excel spreadsheet formulas in which multiple formulas can reference each other. The M engine can determine which expressions are required by the final expression to return and evaluate only those expressions. Configuring Power BI Development Tools, the display setting for both the Query Settings pane and the Formula bar should be enabled as GLOBAL | Query Editor options. Figure 6: Global layout options for the Query Editor Alternatively, on a per file basis, you can control these settings and others from the View tab of the Query Editor toolbar. Figure 7: Property settings of the View tab in the Query Editor Advanced Editor window Given its importance to the query development process, the Advanced Editor dialog is exposed on both the Home and View tabs of the Query Editor. It’s recommended to use the Query Editor when getting started with a new query and when learning the M language. After several steps have been applied, use the Advanced Editor to review and optionally enhance or customize the M query. As a rich, functional programming language, there are many M functions and optional parameters not exposed via the Query Editor; going beyond the limits of the Query Editor enables more robust data retrieval and integration processes. Figure 8: The Home tab of the Query Editor Click on Advanced Editor from either the View or Home tabs (Figure 8 and Figure 9, respectively). All M function expressions and any comments are exposed Figure 9: The Advanced Editor view of the DimGeography query When developing retrieval processes for Power BI models, consider these common ETL questions: How are our queries impacting the source systems? Can we make our retrieval queries more resilient to changes in source data such that they avoid failure? Is our retrieval process efficient and simple to follow and support or are there unnecessary steps and queries? Are our retrieval queries delivering sufficient performance to the BI application? Is our process flexible such that we can quickly apply changes to data sources and logic? M queries are not intended as a substitute for the workloads typically handled by enterprise ETL tools such as SSIS or Informatica. However, just as BI professionals would carefully review the logic and test the performance of SQL stored procedures and ETL packages supporting their various cubes and reports environment, they should also review the M queries created to support Power BI models and reports. How it works Two of the top performance and scalability features of M’s engine are Query Folding and Lazy Evaluation. If possible, the M queries developed in Power BI Desktop are converted (folded) into SQL statements and passed to source systems for processing. M can also reduce the required resources for a given query by ignoring any unnecessary or redundant steps (variables). M is a case-sensitive language. This includes referencing variables in M expressions (RenameColumns versus Renamecolumns) as well as the values in M queries. For example, the values “Apple” and “apple” are considered unique values in an M query; the Table.Distinct() function will not remove rows for one of the values. Variable names in M expressions cannot have spaces without a hash sign and double quotes. Per Figure 10, when the Query Editor graphical interface is used to create M queries this syntax is applied automatically, along with a name describing the M transformation applied. Applying short, descriptive variable names (with no spaces) improves the readability of M queries. Query folding The query from this recipe was “folded” into the following SQL statement and sent to the ATLAS server for processing. Figure 10: The SQL statement generated from the DimGeography M query Right-click on the Filtered Rows step and select View Native Query to access the Native Query window from Figure 11: Figure 11: View Native Query in Query Settings Finding and revising queries that are not being folded to source systems is a top technique for enhancing large Power BI datasets. See the Pushing Query Processing Back to Source Systems recipe of Chapter 11, Enhancing and Optimizing Existing Power BI Solutions for an example of this process. M query structure The great majority of queries created for Power BI will follow the let…in structure as per this recipe, as they contain multiple steps with dependencies among them. Individual expressions are separated by commas. The expression referred to following the in keyword is the expression returned by the query. The individual step expressions are technically “variables”, and if the identifiers for these variables (the names of the query steps) contain spaces then the step is placed in quotes, and prefixed with a # sign as per the Filtered Rows step in Figure 10. Lazy evaluation The M engine also has powerful “lazy evaluation” logic for ignoring any redundant or unnecessary variables, as well as short-circuiting evaluation (computation) once a result is determinate, such as when one side (operand) of an OR logical operator is computed as True. The order of evaluation of the expressions is determined at runtime; it doesn’t have to be sequential from top to bottom. In the following example, a step for retrieving Canada was added and the step for the United States was ignored. Since the CanadaOnly variable satisfies the overall let expression of the query, only the Canada query is issued to the server as if the United States row were commented out or didn’t exist. Figure 12: Revised query that ignores Filtered Rows step to evaluate Canada only View Native Query (Figure 12) is not available given this revision, but a SQL Profiler trace against the source database server (and a refresh of the M query) confirms that CanadaOnly was the only SQL query passed to the source database. Figure 13: Capturing the SQL statement passed to the server via SQL Server Profiler trace There’s more Partial query folding A query can be “partially folded”, in which a SQL statement is created resolving only part of an overall query The results of this SQL statement would be returned to Power BI Desktop (or the on-premises data gateway) and the remaining logic would be computed using M’s in-memory engine with local resources M queries can be designed to maximize the use of the source system resources, by using standard expressions supported by query folding early in the query process Minimizing the use of local or on-premises data gateway resources is a top consideration Limitations of query folding No folding will take place once a native SQL query has been passed to the source system. For example, passing a SQL query directly through the Get Data dialog. The following query, specified in the Get Data dialog, is included in the Source Step: Figure 14: Providing a user defined native SQL query Any transformations applied after this native query will use local system resources. Therefore, the general implication for query development with native or user-defined SQL queries is that if they’re used, try to include all required transformations (that is, joins and derived columns), or use them to utilize an important feature of the source database not being utilized by the folded query, such as an index. Not all data sources support query folding, such as text and Excel files. Not all transformations available in the Query Editor or via M functions directly are supported by some data sources. The privacy levels defined for the data sources will also impact whether folding is used or not. SQL statements are not parsed before they’re sent to the source system. The Table.Buffer() function can be used to avoid query folding. The table output of this function is loaded into local memory and transformations against it will remain local. We have discussed effective techniques for accessing and retrieving data using Microsoft Power BI. Do check out this book Microsoft Power BI Cookbook for more information on using Microsoft power BI for data analysis and visualization. Read Next: Expert Interview: Unlocking the secrets of Microsoft Power BI Tutorial: Building a Microsoft Power BI Data Model Expert Insights:Ride the third wave of BI with Microsoft Power BI
<< Previous PostNext Post >> Share IATA reports strong year for air travel demand, says “aviation is the business of freedom” GENEVA — In light of the U.S. immigrant ban that has sparked controversy and protests across the country, IATA, in its full-year global passenger traffic report, says that “aviation is the business of freedom” and that its social and economic benefits must be defended “from barriers to travel and protectionist agendas.”According to the report, air travel demand had a strong year in 2016, closing out the year on a high note with an 8.8% increase in December. Demand (measured in revenue passenger kilometres, or RPKs) rose 6.3% compared to 2015, well ahead of the 10-year average annual growth rate of 5.5%. Capacity also rose 6.2% compared to 2015, pushing the load factor up to a record full-year average high of 80.5%.“Air travel was a good news story in 2016. Connectivity increased with the establishment of more than 700 new routes. And a $44 fall in average return fares helped to make air travel even more accessible,” said Alexandre de Juniac, IATA’s Director General and CEO. “As a result, a record 3.7 billion passengers flew safely to their destination. Demand for air travel is still expanding.”More news: Transat calls Groupe Mach’s latest offer “highly abusive, coercive and misleading”De Juniac also added: “Our freedom to connect through air travel drives prosperity and enriches societies. That freedom can only be given its fullest expression when governments facilitate the movement of people and goods.”International passenger traffic rose 6.7% in 2016 compared to 2015, with all regions recording year-over-year increases in demand. Middle East carriers had the strongest regional annual traffic growth for the fifth year in a row, with RPKs expanding 11.8%. Asia Pacific carriers came in a close second with a demand increase of 8.3% compared to 2015.North American airlines had a good year as well, seeing demand rise 2.6% in 2016. Most of the growth occurred in the second quarter, and traffic was strongest on Pacific routes. In contrast, North Atlantic has been fairly flat. Capacity rose 3.3%, reducing the load factor for 0.5 percentage points to 81.3%.Domestic air travel rose 5.7% in 2016. Capacity rose 5.1% and load factor was 82.2%, up 0.5 percentage points over 2015. All major markets except Brazil showed growth, with India and China being the standout performers (RPK expansion of 23.3% and 11.7%, respectively). Tags: IATA Travelweek Group Thursday, February 2, 2017 Posted by